Database Changes for 4.34
This section contains details of database changes between the full 4.33 and 4.34 releases.
Table changes:

The following tables have been added.
Table Name | Column Name |
---|---|
COHORTS | Details of all cohort groups. |
COHORT_FILTERS | Many-to-Many linking of cohort groups to filter definitions. |
COHORT_FILTER_VALUES | Selected values for each filter associated with each cohort. |
COHORT_PERIODS | Applicable periods to which a cohort group applies to. |
FILTER_DEFINITIONS | Details of all filter definitions, used for example when creating cohort groups. |

The following columns have been added.
Table Name | Column Name | Type (Size) | Nullable | Description |
---|---|---|---|---|
PEOPLE_CDR | HOMELESS_EXCLUSION | VARCHAR2(10) | Y | Homeless or affected by Housing Exclusion is defined as being roofless or houseless i.e. (sleeping rough), it may also include situations of living in temporary, insecure or poor-quality housing. [FK=CDR_VERIFIERS.CODE(RV_DOMAIN=HOMELESS_EXCLUSION)] |
PEOPLE_CDR | LONG_TERM_DESTINATION | VARCHAR2(10) | Y | The current main employment status. [FK=CDR_VERIFIERS.CODE(RV_DOMAIN=LTDESTINATION)] |
PEOPLE_CDR | LONG_TERM_EMPLOYMENT | VARCHAR2(10) | Y | The employment situation on joining the programme. [FK=CDR_VERIFIERS.CODE(RV_DOMAIN=LTEMPLOYMENT)] |
PEOPLE_CDR | VPRS | VARCHAR2(1) | N | Should be selected if a student is participating in Vulnerable Persons Relocation Scheme. [FK=CDR_VERIFIERS.CODE(RV_DOMAIN=VPRS)] [DEFAULT=0] |
PEOPLE_HESA | NATION | VARCHAR2(2) | Y | The country of the legal nationality of a student. [FK=HESA_VERIFIERS.CODE(RV_DOMAIN=NATION)] |

The following columns have been changed.
Table Name | Column Name | Type (Size) | Nullable | Previous Values Type (Size) [Nullable] |
---|---|---|---|---|
HOURS_STATISTICS | COURSE_HOURS | NUMBER(10,2) | Y | NUMBER(5,2)[Y] |
HOURS_STATISTICS | NOTIONAL_STUDENT_HOURS | NUMBER(10,2) | Y | NUMBER(5,2)[Y] |
HOURS_STATISTICS | STUDENT_HOURS | NUMBER(10,2) | Y | NUMBER(5,2)[Y] |
HOURS_STATISTICS | TOTAL_STUDENT_HOURS | NUMBER(10,2) | Y | NUMBER(6,2)[Y] |
View changes:

The EBS_VERIFIER_CUSTOM_WEB_CONFIG view has been added.

The following columns have been added.
View Name | Column Name |
---|---|
DM_APP_OFFERS | OFFER_TO_ACCEPT_DAYS |
EBS_CDRGENERATERETURN | REL_BROUGHT |
EBS_EXAM_CANDIDATES | HOMELESS_EXCLUSION |
EBS_EXAM_CANDIDATES | P_CDR_LONG_TERM_DESTINATION |
EBS_EXAM_CANDIDATES | P_CDR_LONG_TERM_EMPLOYMENT |
EBS_EXAM_CANDIDATES | VPRS |
EBS_LEARNERS | HOMELESS_EXCLUSION |
EBS_LEARNERS | P_CDR_LONG_TERM_DESTINATION |
EBS_LEARNERS | VPRS |
EBS_LEARNERS | P_CDR_LONG_TERM_EMPLOYMENT |
EBS_LEARNERS_DEDUP | HOMELESS_EXCLUSION |
EBS_LEARNERS_DEDUP | P_CDR_LONG_TERM_DESTINATION |
EBS_LEARNERS_DEDUP | VPRS |
EBS_LEARNERS_DEDUP | P_CDR_LONG_TERM_EMPLOYMENT |
EBS_STAFFUSER | PERSONAL_EMAIL |

The following columns have been dropped.
View Name | Column Name |
---|---|
EBS_CDRGENERATERETURN | COM_BACKGROUND |
Service Pack 4 Changes
The following changes have been made for 4.34 Service Pack 4:

The following columns have been added.
Table Name | Column Name | Type (Size) | Nullable | Description |
---|---|---|---|---|
UIO_HESA | UNITLGTH | VARCHAR2(1) | Y | Specifies the duration of a unit in order to describe the length of the course for a HESA SA return (for example: day, month, year and so on). |
UIO_HESA | SPLENGTH | NUMERIC(2) | Y | Number of units to describe the length of the course for a HESA SA return. |